package com.neu.carbon.mes.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface FactoryMapper {
    @Select("select product_line_name from mes_factory_model where id=#{productLineId}")
    String selectNameById(Long productLineId);

    @Select("select product_line_name from mes_factory_model where id=#{materialId}")
    String selectNameByMaterial(Long materialId);

    @Select("select id from mes_factory_model where material_id=#{materialId} ")
    Long selectIdByMaterial(Long materialId);
}

